<?php
/**
 *	[alias(alias.install)] (C)2012-2099 Powered by abans@qq.com.
 *	Version: 1.0
 *	Date: 2012-10-29 13:21
 */

if(!defined('IN_DISCUZ')) {
	exit('Access Denied');
}


$sql = <<<EOF
CREATE TABLE IF NOT EXISTS `pre_plugin_push_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` int(10) NOT NULL,
  `rid` int(10) NOT NULL,
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `date` (`date`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `pre_plugin_push_set` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `uid` mediumint(8) unsigned NOT NULL,
  `mail` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `uid` (`uid`)
) ENGINE=MyISAM;

CREATE TABLE IF NOT EXISTS `pre_plugin_push_bind` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `rid` int(10) NOT NULL,
  `mail` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM;
EOF;
runquery($sql);
$finish = TRUE;

?>